﻿CREATE TABLE [dbo].[BankTransaction] (
    [ID_BankTransaction]      INT           IDENTITY (1, 1) NOT NULL,
    [Id_BankAccount]          INT           NOT NULL,
    [BankTransactionType]     INT           NOT NULL,
    [TransactionDate]         SMALLDATETIME NOT NULL,
    [Document]                VARCHAR (15)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Description]             VARCHAR (100) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Id_CostCenter]           INT           NULL,
    [Id_Account]              INT           NULL,
    [Id_Supplier]             INT           NULL,
    [Id_Client]               INT           NULL,
    [TransactionValue]        MONEY         NULL,
    [Id_BankAccount_Transfer] INT           NULL
);

